{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Project Assumptions","Group","Employee Rates","Copy To Sharepoint","Instructions","Data Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Project Assumptions","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,5,35,8],[3,3,3,5],[4,3,4,5],[1,1,1,6],[8,1,8,2],[7,1,7,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[5,3,5,5]]}
[]
[null,"Fixed Fee per Hour Calculation Worksheet",null,null,null,null,null,"Rev. 7/7/2017"]
[null,null,null,null,null,null,null,"Today's Date:",null,null,null,{"$f":"IF(OR(ISBLANK(I3),ISBLANK(I4),ISBLANK(I5),ISBLANK(I6))=TRUE,\"No\",\"Yes\")","v":"No"},"<---Are all wage escalation factor computation cells completed? (cells I3:I6)"]
[null,"Agreement No.:",null,null,null,null,null,"Project Start Date:"]
[null,"C-R-S:",null,null,null,null,null,"Project End Date:",null,null,null,{"$f":"IF(OR(ISBLANK(D9),ISBLANK(D8))=TRUE,\"No\",\"Yes\")","v":"No"},"<---Are all fixed fee computation cells completed?  (cells D8:D9)"]
[null,"Firm Name:",null,null,null,null,null,"Annual Wage Escalation %:"]
[]
[null,"Weighted Avg OH:",null,1.5808]
[null,"Net Fee:"]
[]
[null,null,null,null,null,"Instructions"]
[null,null,"Group","Fixed Fee"]
[null,null,1,{"$f":"'Data Tables'!F8","v":0}]
[null,null,2,{"$f":"'Data Tables'!F9","v":0},null,"Special instructions to ODOT (optional):"]
[null,null,3,{"$f":"'Data Tables'!F10","v":0},null,"Type Alt+Enter for a new paragraph"]
[null,null,4,{"$f":"'Data Tables'!F11","v":0}]
[null,null,5,{"$f":"'Data Tables'!F12","v":0}]
[null,null,6,{"$f":"'Data Tables'!F13","v":0}]
[null,null,7,{"$f":"'Data Tables'!F14","v":0}]
[null,null,8,{"$f":"'Data Tables'!F15","v":0}]
[null,null,9,{"$f":"'Data Tables'!F16","v":0}]
[null,null,10,{"$f":"'Data Tables'!F17","v":0}]
[null,null,11,{"$f":"'Data Tables'!F18","v":0}]
[null,null,12,{"$f":"'Data Tables'!F19","v":0}]
[null,null,13,{"$f":"'Data Tables'!F20","v":0}]
[null,null,14,{"$f":"'Data Tables'!F21","v":0}]
[null,null,15,{"$f":"'Data Tables'!F22","v":0}]
[null,null,16,{"$f":"'Data Tables'!F23","v":0}]
[null,null,17,{"$f":"'Data Tables'!F24","v":0}]
[null,null,18,{"$f":"'Data Tables'!F25","v":0}]
[null,null,19,{"$f":"'Data Tables'!F26","v":0}]
[null,null,20,{"$f":"'Data Tables'!F27","v":0}]
[null,null,21,{"$f":"'Data Tables'!F28","v":0}]
[null,null,22,{"$f":"'Data Tables'!F29","v":0}]
[null,null,23,{"$f":"'Data Tables'!F30","v":0}]
[null,null,24,{"$f":"'Data Tables'!F31","v":0}]

{"sheet":"Group","index":1,"n_rows":219,"n_cols":4,"rows_kept":219,"cut":false,"hidden":true,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2],[0,0,0,4]]}
["Employee Identifcation by Group"]
[]
[null,"Agreement No.:",null,{"$f":"'Project Assumptions'!$D$4","v":0}]
[null,"C-R-S:",null,{"$f":"'Project Assumptions'!$D$5","v":0}]
[null,"Firm Name:",null,{"$f":"'Project Assumptions'!$D$6","v":0}]
[]
[null,"Raw Rate Range $<15",null,"Raw Rate Range $15.01<$20"]
[null,"Group 1",null,"Group 2"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $20.01<$25",null,"Raw Rate Range $25.01<$30"]
[null,"Group 3",null,"Group 4"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $30.01<$35",null,"Raw Rate Range $35.01<$40"]
[null,"Group 5",null,"Group 6"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $40.01<$45",null,"Raw Rate Range $45.01<$50"]
[null,"Group 7",null,"Group 8"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $50.01<$55",null,"Raw Rate Range $55.01<$60"]
[null,"Group 9",null,"Group 10"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $60.01<$65",null,"Raw Rate Range $65.01<$70"]
[null,"Group 11",null,"Group 12"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $70.01<$75",null,"Raw Rate Range $75.01<$80"]
[null,"Group 13",null,"Group 14"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $80.01<$85",null,"Raw Rate Range $85.01<$90"]
[null,"Group 15",null,"Group 16"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $90.01<95",null,"Raw Rate Range $95.01<$100"]
[null,"Group 17",null,"Group 18"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $100.01<$105",null,"Raw Rate Range $105.01<$110"]
[null,"Group 19",null,"Group 20"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $110.01<$115",null,"Raw Rate Range $115.01<$120"]
[null,"Group 21",null,"Group 22"]
[null,"Name",null,"Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Raw Rate Range $120.01<$125",null,"Raw Rate Range $>$125.01"]
[null,"Group 23",null,"Group 24"]
[null,"Name",null,"Name"]

{"sheet":"Employee Rates","index":2,"n_rows":209,"n_cols":7,"rows_kept":209,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,7],[1,1,1,7],[3,3,3,7],[4,3,4,7],[3,1,3,2],[4,1,4,2]]}
[]
[null,"Employee Names and Hourly Pay Rates"]
[]
[null,"Agreement No.:",null,{"$f":"IF(ISBLANK('Project Assumptions'!D4),\"\",'Project Assumptions'!D4)","v":""}]
[null,"C-R-S:",null,{"$f":"IF(ISBLANK('Project Assumptions'!D5),\"\",'Project Assumptions'!D5)","v":""}]
[null,"Firm Name:",null,{"$f":"IF(ISBLANK('Project Assumptions'!D6),\"\",'Project Assumptions'!D6)","v":""}]
[]
[]
[null,"Employee Name","Pay Rate","Esc. Pay Rate","Group","Fixed Fee"]
[null,null,null,{"$f":"IF(ISBLANK(C10),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C10,ROUND(C10*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C10),\"\",VLOOKUP(D10,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C10),\"\",VLOOKUP(E10,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""},"<--Enter employee names and actual pay rates as of today's date. Salaried employee rates should be based on methodology (standard or effective) consistently used by the firm."]
[null,null,null,{"$f":"IF(ISBLANK(C11),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C11,ROUND(C11*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C11),\"\",VLOOKUP(D11,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C11),\"\",VLOOKUP(E11,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C12),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C12,ROUND(C12*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C12),\"\",VLOOKUP(D12,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C12),\"\",VLOOKUP(E12,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C13),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C13,ROUND(C13*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(D13,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(E13,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C14),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C14,ROUND(C14*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(D14,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(E14,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C15),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C15,ROUND(C15*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(D15,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(E15,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C16),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C16,ROUND(C16*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(D16,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(E16,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C17),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C17,ROUND(C17*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(D17,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(E17,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C18),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C18,ROUND(C18*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(D18,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(E18,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C19),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C19,ROUND(C19*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(D19,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(E19,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C20),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C20,ROUND(C20*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(D20,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(E20,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C21),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C21,ROUND(C21*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(D21,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(E21,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C22),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C22,ROUND(C22*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(D22,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(E22,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C23),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C23,ROUND(C23*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(D23,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(E23,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C24),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C24,ROUND(C24*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(D24,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(E24,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C25),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C25,ROUND(C25*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(D25,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(E25,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C26),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C26,ROUND(C26*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(D26,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(E26,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C27),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C27,ROUND(C27*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(D27,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(E27,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C28),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C28,ROUND(C28*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C28),\"\",VLOOKUP(D28,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C28),\"\",VLOOKUP(E28,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C29),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C29,ROUND(C29*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C29),\"\",VLOOKUP(D29,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C29),\"\",VLOOKUP(E29,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C30),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C30,ROUND(C30*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C30),\"\",VLOOKUP(D30,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C30),\"\",VLOOKUP(E30,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C31),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C31,ROUND(C31*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C31),\"\",VLOOKUP(D31,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C31),\"\",VLOOKUP(E31,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C32),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C32,ROUND(C32*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C32),\"\",VLOOKUP(D32,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C32),\"\",VLOOKUP(E32,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C33),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C33,ROUND(C33*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C33),\"\",VLOOKUP(D33,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C33),\"\",VLOOKUP(E33,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C34),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C34,ROUND(C34*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(D34,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(E34,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C35),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C35,ROUND(C35*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C35),\"\",VLOOKUP(D35,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C35),\"\",VLOOKUP(E35,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C36),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C36,ROUND(C36*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C36),\"\",VLOOKUP(D36,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C36),\"\",VLOOKUP(E36,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C37),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C37,ROUND(C37*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C37),\"\",VLOOKUP(D37,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C37),\"\",VLOOKUP(E37,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C38),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C38,ROUND(C38*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C38),\"\",VLOOKUP(D38,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C38),\"\",VLOOKUP(E38,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C39),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C39,ROUND(C39*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C39),\"\",VLOOKUP(D39,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C39),\"\",VLOOKUP(E39,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C40),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C40,ROUND(C40*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C40),\"\",VLOOKUP(D40,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C40),\"\",VLOOKUP(E40,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C41),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C41,ROUND(C41*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C41),\"\",VLOOKUP(D41,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C41),\"\",VLOOKUP(E41,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C42),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C42,ROUND(C42*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C42),\"\",VLOOKUP(D42,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C42),\"\",VLOOKUP(E42,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C43),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C43,ROUND(C43*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C43),\"\",VLOOKUP(D43,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C43),\"\",VLOOKUP(E43,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C44),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C44,ROUND(C44*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C44),\"\",VLOOKUP(D44,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C44),\"\",VLOOKUP(E44,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C45),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C45,ROUND(C45*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C45),\"\",VLOOKUP(D45,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C45),\"\",VLOOKUP(E45,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C46),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C46,ROUND(C46*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C46),\"\",VLOOKUP(D46,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C46),\"\",VLOOKUP(E46,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C47),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C47,ROUND(C47*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C47),\"\",VLOOKUP(D47,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C47),\"\",VLOOKUP(E47,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C48),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C48,ROUND(C48*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C48),\"\",VLOOKUP(D48,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C48),\"\",VLOOKUP(E48,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C49),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C49,ROUND(C49*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C49),\"\",VLOOKUP(D49,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C49),\"\",VLOOKUP(E49,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C50),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C50,ROUND(C50*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C50),\"\",VLOOKUP(D50,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C50),\"\",VLOOKUP(E50,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C51),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C51,ROUND(C51*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C51),\"\",VLOOKUP(D51,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C51),\"\",VLOOKUP(E51,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C52),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C52,ROUND(C52*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C52),\"\",VLOOKUP(D52,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C52),\"\",VLOOKUP(E52,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C53),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C53,ROUND(C53*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C53),\"\",VLOOKUP(D53,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C53),\"\",VLOOKUP(E53,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C54),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C54,ROUND(C54*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C54),\"\",VLOOKUP(D54,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C54),\"\",VLOOKUP(E54,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C55),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C55,ROUND(C55*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C55),\"\",VLOOKUP(D55,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C55),\"\",VLOOKUP(E55,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C56),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C56,ROUND(C56*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C56),\"\",VLOOKUP(D56,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C56),\"\",VLOOKUP(E56,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C57),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C57,ROUND(C57*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C57),\"\",VLOOKUP(D57,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C57),\"\",VLOOKUP(E57,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C58),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C58,ROUND(C58*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C58),\"\",VLOOKUP(D58,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C58),\"\",VLOOKUP(E58,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C59),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C59,ROUND(C59*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C59),\"\",VLOOKUP(D59,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C59),\"\",VLOOKUP(E59,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""},"Back to Top"]
[null,null,null,{"$f":"IF(ISBLANK(C60),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C60,ROUND(C60*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C60),\"\",VLOOKUP(D60,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C60),\"\",VLOOKUP(E60,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C61),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C61,ROUND(C61*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C61),\"\",VLOOKUP(D61,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C61),\"\",VLOOKUP(E61,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C62),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C62,ROUND(C62*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C62),\"\",VLOOKUP(D62,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C62),\"\",VLOOKUP(E62,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C63),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C63,ROUND(C63*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C63),\"\",VLOOKUP(D63,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C63),\"\",VLOOKUP(E63,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C64),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C64,ROUND(C64*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C64),\"\",VLOOKUP(D64,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C64),\"\",VLOOKUP(E64,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C65),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C65,ROUND(C65*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C65),\"\",VLOOKUP(D65,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C65),\"\",VLOOKUP(E65,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C66),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C66,ROUND(C66*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C66),\"\",VLOOKUP(D66,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C66),\"\",VLOOKUP(E66,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C67),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C67,ROUND(C67*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C67),\"\",VLOOKUP(D67,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C67),\"\",VLOOKUP(E67,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C68),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C68,ROUND(C68*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C68),\"\",VLOOKUP(D68,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C68),\"\",VLOOKUP(E68,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C69),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C69,ROUND(C69*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C69),\"\",VLOOKUP(D69,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C69),\"\",VLOOKUP(E69,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C70),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C70,ROUND(C70*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C70),\"\",VLOOKUP(D70,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C70),\"\",VLOOKUP(E70,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C71),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C71,ROUND(C71*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C71),\"\",VLOOKUP(D71,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C71),\"\",VLOOKUP(E71,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C72),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C72,ROUND(C72*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C72),\"\",VLOOKUP(D72,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C72),\"\",VLOOKUP(E72,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C73),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C73,ROUND(C73*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C73),\"\",VLOOKUP(D73,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C73),\"\",VLOOKUP(E73,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C74),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C74,ROUND(C74*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C74),\"\",VLOOKUP(D74,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C74),\"\",VLOOKUP(E74,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C75),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C75,ROUND(C75*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C75),\"\",VLOOKUP(D75,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C75),\"\",VLOOKUP(E75,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C76),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C76,ROUND(C76*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C76),\"\",VLOOKUP(D76,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C76),\"\",VLOOKUP(E76,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C77),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C77,ROUND(C77*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C77),\"\",VLOOKUP(D77,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C77),\"\",VLOOKUP(E77,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C78),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C78,ROUND(C78*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C78),\"\",VLOOKUP(D78,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C78),\"\",VLOOKUP(E78,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C79),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C79,ROUND(C79*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C79),\"\",VLOOKUP(D79,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C79),\"\",VLOOKUP(E79,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C80),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C80,ROUND(C80*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C80),\"\",VLOOKUP(D80,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C80),\"\",VLOOKUP(E80,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C81),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C81,ROUND(C81*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C81),\"\",VLOOKUP(D81,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C81),\"\",VLOOKUP(E81,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C82),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C82,ROUND(C82*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C82),\"\",VLOOKUP(D82,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C82),\"\",VLOOKUP(E82,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C83),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C83,ROUND(C83*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C83),\"\",VLOOKUP(D83,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C83),\"\",VLOOKUP(E83,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C84),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C84,ROUND(C84*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C84),\"\",VLOOKUP(D84,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C84),\"\",VLOOKUP(E84,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C85),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C85,ROUND(C85*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C85),\"\",VLOOKUP(D85,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C85),\"\",VLOOKUP(E85,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C86),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C86,ROUND(C86*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C86),\"\",VLOOKUP(D86,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C86),\"\",VLOOKUP(E86,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C87),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C87,ROUND(C87*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C87),\"\",VLOOKUP(D87,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C87),\"\",VLOOKUP(E87,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C88),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C88,ROUND(C88*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C88),\"\",VLOOKUP(D88,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C88),\"\",VLOOKUP(E88,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C89),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C89,ROUND(C89*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C89),\"\",VLOOKUP(D89,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C89),\"\",VLOOKUP(E89,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C90),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C90,ROUND(C90*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C90),\"\",VLOOKUP(D90,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C90),\"\",VLOOKUP(E90,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C91),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C91,ROUND(C91*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C91),\"\",VLOOKUP(D91,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C91),\"\",VLOOKUP(E91,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C92),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C92,ROUND(C92*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C92),\"\",VLOOKUP(D92,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C92),\"\",VLOOKUP(E92,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C93),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C93,ROUND(C93*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C93),\"\",VLOOKUP(D93,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C93),\"\",VLOOKUP(E93,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C94),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C94,ROUND(C94*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C94),\"\",VLOOKUP(D94,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C94),\"\",VLOOKUP(E94,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C95),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C95,ROUND(C95*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C95),\"\",VLOOKUP(D95,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C95),\"\",VLOOKUP(E95,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C96),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C96,ROUND(C96*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C96),\"\",VLOOKUP(D96,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C96),\"\",VLOOKUP(E96,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C97),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C97,ROUND(C97*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C97),\"\",VLOOKUP(D97,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C97),\"\",VLOOKUP(E97,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C98),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C98,ROUND(C98*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C98),\"\",VLOOKUP(D98,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C98),\"\",VLOOKUP(E98,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C99),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C99,ROUND(C99*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C99),\"\",VLOOKUP(D99,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C99),\"\",VLOOKUP(E99,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C100),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C100,ROUND(C100*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C100),\"\",VLOOKUP(D100,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C100),\"\",VLOOKUP(E100,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C101),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C101,ROUND(C101*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C101),\"\",VLOOKUP(D101,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C101),\"\",VLOOKUP(E101,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C102),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C102,ROUND(C102*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C102),\"\",VLOOKUP(D102,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C102),\"\",VLOOKUP(E102,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C103),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C103,ROUND(C103*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C103),\"\",VLOOKUP(D103,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C103),\"\",VLOOKUP(E103,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C104),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C104,ROUND(C104*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C104),\"\",VLOOKUP(D104,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C104),\"\",VLOOKUP(E104,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C105),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C105,ROUND(C105*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C105),\"\",VLOOKUP(D105,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C105),\"\",VLOOKUP(E105,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C106),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C106,ROUND(C106*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C106),\"\",VLOOKUP(D106,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C106),\"\",VLOOKUP(E106,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C107),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C107,ROUND(C107*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C107),\"\",VLOOKUP(D107,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C107),\"\",VLOOKUP(E107,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C108),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C108,ROUND(C108*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C108),\"\",VLOOKUP(D108,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C108),\"\",VLOOKUP(E108,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C109),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C109,ROUND(C109*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C109),\"\",VLOOKUP(D109,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C109),\"\",VLOOKUP(E109,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""},"Back to Top"]
[null,null,null,{"$f":"IF(ISBLANK(C110),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C110,ROUND(C110*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C110),\"\",VLOOKUP(D110,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C110),\"\",VLOOKUP(E110,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C111),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C111,ROUND(C111*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C111),\"\",VLOOKUP(D111,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C111),\"\",VLOOKUP(E111,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C112),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C112,ROUND(C112*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C112),\"\",VLOOKUP(D112,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C112),\"\",VLOOKUP(E112,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C113),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C113,ROUND(C113*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C113),\"\",VLOOKUP(D113,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C113),\"\",VLOOKUP(E113,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C114),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C114,ROUND(C114*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C114),\"\",VLOOKUP(D114,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C114),\"\",VLOOKUP(E114,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C115),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C115,ROUND(C115*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C115),\"\",VLOOKUP(D115,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C115),\"\",VLOOKUP(E115,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C116),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C116,ROUND(C116*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C116),\"\",VLOOKUP(D116,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C116),\"\",VLOOKUP(E116,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C117),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C117,ROUND(C117*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C117),\"\",VLOOKUP(D117,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C117),\"\",VLOOKUP(E117,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C118),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C118,ROUND(C118*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C118),\"\",VLOOKUP(D118,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C118),\"\",VLOOKUP(E118,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C119),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C119,ROUND(C119*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C119),\"\",VLOOKUP(D119,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C119),\"\",VLOOKUP(E119,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C120),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C120,ROUND(C120*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C120),\"\",VLOOKUP(D120,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C120),\"\",VLOOKUP(E120,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C121),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C121,ROUND(C121*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C121),\"\",VLOOKUP(D121,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C121),\"\",VLOOKUP(E121,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C122),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C122,ROUND(C122*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C122),\"\",VLOOKUP(D122,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C122),\"\",VLOOKUP(E122,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C123),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C123,ROUND(C123*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C123),\"\",VLOOKUP(D123,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C123),\"\",VLOOKUP(E123,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C124),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C124,ROUND(C124*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C124),\"\",VLOOKUP(D124,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C124),\"\",VLOOKUP(E124,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C125),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C125,ROUND(C125*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C125),\"\",VLOOKUP(D125,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C125),\"\",VLOOKUP(E125,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C126),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C126,ROUND(C126*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C126),\"\",VLOOKUP(D126,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C126),\"\",VLOOKUP(E126,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C127),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C127,ROUND(C127*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C127),\"\",VLOOKUP(D127,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C127),\"\",VLOOKUP(E127,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C128),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C128,ROUND(C128*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C128),\"\",VLOOKUP(D128,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C128),\"\",VLOOKUP(E128,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C129),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C129,ROUND(C129*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C129),\"\",VLOOKUP(D129,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C129),\"\",VLOOKUP(E129,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C130),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C130,ROUND(C130*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C130),\"\",VLOOKUP(D130,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C130),\"\",VLOOKUP(E130,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C131),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C131,ROUND(C131*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C131),\"\",VLOOKUP(D131,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C131),\"\",VLOOKUP(E131,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C132),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C132,ROUND(C132*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C132),\"\",VLOOKUP(D132,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C132),\"\",VLOOKUP(E132,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C133),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C133,ROUND(C133*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C133),\"\",VLOOKUP(D133,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C133),\"\",VLOOKUP(E133,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C134),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C134,ROUND(C134*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C134),\"\",VLOOKUP(D134,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C134),\"\",VLOOKUP(E134,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C135),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C135,ROUND(C135*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C135),\"\",VLOOKUP(D135,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C135),\"\",VLOOKUP(E135,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C136),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C136,ROUND(C136*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C136),\"\",VLOOKUP(D136,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C136),\"\",VLOOKUP(E136,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C137),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C137,ROUND(C137*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C137),\"\",VLOOKUP(D137,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C137),\"\",VLOOKUP(E137,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C138),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C138,ROUND(C138*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C138),\"\",VLOOKUP(D138,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C138),\"\",VLOOKUP(E138,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C139),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C139,ROUND(C139*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C139),\"\",VLOOKUP(D139,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C139),\"\",VLOOKUP(E139,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C140),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C140,ROUND(C140*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C140),\"\",VLOOKUP(D140,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C140),\"\",VLOOKUP(E140,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C141),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C141,ROUND(C141*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C141),\"\",VLOOKUP(D141,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C141),\"\",VLOOKUP(E141,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C142),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C142,ROUND(C142*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C142),\"\",VLOOKUP(D142,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C142),\"\",VLOOKUP(E142,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C143),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C143,ROUND(C143*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C143),\"\",VLOOKUP(D143,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C143),\"\",VLOOKUP(E143,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C144),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C144,ROUND(C144*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C144),\"\",VLOOKUP(D144,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C144),\"\",VLOOKUP(E144,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C145),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C145,ROUND(C145*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C145),\"\",VLOOKUP(D145,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C145),\"\",VLOOKUP(E145,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C146),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C146,ROUND(C146*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C146),\"\",VLOOKUP(D146,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C146),\"\",VLOOKUP(E146,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C147),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C147,ROUND(C147*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C147),\"\",VLOOKUP(D147,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C147),\"\",VLOOKUP(E147,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C148),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C148,ROUND(C148*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C148),\"\",VLOOKUP(D148,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C148),\"\",VLOOKUP(E148,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C149),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C149,ROUND(C149*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C149),\"\",VLOOKUP(D149,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C149),\"\",VLOOKUP(E149,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C150),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C150,ROUND(C150*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C150),\"\",VLOOKUP(D150,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C150),\"\",VLOOKUP(E150,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C151),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C151,ROUND(C151*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C151),\"\",VLOOKUP(D151,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C151),\"\",VLOOKUP(E151,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C152),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C152,ROUND(C152*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C152),\"\",VLOOKUP(D152,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C152),\"\",VLOOKUP(E152,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C153),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C153,ROUND(C153*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C153),\"\",VLOOKUP(D153,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C153),\"\",VLOOKUP(E153,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C154),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C154,ROUND(C154*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C154),\"\",VLOOKUP(D154,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C154),\"\",VLOOKUP(E154,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C155),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C155,ROUND(C155*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C155),\"\",VLOOKUP(D155,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C155),\"\",VLOOKUP(E155,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C156),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C156,ROUND(C156*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C156),\"\",VLOOKUP(D156,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C156),\"\",VLOOKUP(E156,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C157),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C157,ROUND(C157*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C157),\"\",VLOOKUP(D157,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C157),\"\",VLOOKUP(E157,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C158),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C158,ROUND(C158*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C158),\"\",VLOOKUP(D158,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C158),\"\",VLOOKUP(E158,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C159),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C159,ROUND(C159*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C159),\"\",VLOOKUP(D159,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C159),\"\",VLOOKUP(E159,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""},"Back to Top"]
[null,null,null,{"$f":"IF(ISBLANK(C160),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C160,ROUND(C160*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C160),\"\",VLOOKUP(D160,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C160),\"\",VLOOKUP(E160,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C161),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C161,ROUND(C161*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C161),\"\",VLOOKUP(D161,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C161),\"\",VLOOKUP(E161,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C162),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C162,ROUND(C162*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C162),\"\",VLOOKUP(D162,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C162),\"\",VLOOKUP(E162,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C163),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C163,ROUND(C163*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C163),\"\",VLOOKUP(D163,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C163),\"\",VLOOKUP(E163,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C164),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C164,ROUND(C164*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C164),\"\",VLOOKUP(D164,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C164),\"\",VLOOKUP(E164,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C165),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C165,ROUND(C165*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C165),\"\",VLOOKUP(D165,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C165),\"\",VLOOKUP(E165,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C166),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C166,ROUND(C166*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C166),\"\",VLOOKUP(D166,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C166),\"\",VLOOKUP(E166,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C167),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C167,ROUND(C167*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C167),\"\",VLOOKUP(D167,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C167),\"\",VLOOKUP(E167,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C168),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C168,ROUND(C168*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C168),\"\",VLOOKUP(D168,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C168),\"\",VLOOKUP(E168,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C169),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C169,ROUND(C169*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C169),\"\",VLOOKUP(D169,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C169),\"\",VLOOKUP(E169,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C170),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C170,ROUND(C170*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C170),\"\",VLOOKUP(D170,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C170),\"\",VLOOKUP(E170,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C171),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C171,ROUND(C171*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C171),\"\",VLOOKUP(D171,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C171),\"\",VLOOKUP(E171,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C172),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C172,ROUND(C172*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C172),\"\",VLOOKUP(D172,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C172),\"\",VLOOKUP(E172,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C173),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C173,ROUND(C173*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C173),\"\",VLOOKUP(D173,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C173),\"\",VLOOKUP(E173,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C174),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C174,ROUND(C174*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C174),\"\",VLOOKUP(D174,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C174),\"\",VLOOKUP(E174,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C175),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C175,ROUND(C175*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C175),\"\",VLOOKUP(D175,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C175),\"\",VLOOKUP(E175,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C176),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C176,ROUND(C176*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C176),\"\",VLOOKUP(D176,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C176),\"\",VLOOKUP(E176,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C177),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C177,ROUND(C177*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C177),\"\",VLOOKUP(D177,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C177),\"\",VLOOKUP(E177,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C178),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C178,ROUND(C178*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C178),\"\",VLOOKUP(D178,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C178),\"\",VLOOKUP(E178,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C179),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C179,ROUND(C179*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C179),\"\",VLOOKUP(D179,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C179),\"\",VLOOKUP(E179,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C180),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C180,ROUND(C180*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C180),\"\",VLOOKUP(D180,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C180),\"\",VLOOKUP(E180,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C181),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C181,ROUND(C181*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C181),\"\",VLOOKUP(D181,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C181),\"\",VLOOKUP(E181,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C182),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C182,ROUND(C182*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C182),\"\",VLOOKUP(D182,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C182),\"\",VLOOKUP(E182,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C183),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C183,ROUND(C183*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C183),\"\",VLOOKUP(D183,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C183),\"\",VLOOKUP(E183,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C184),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C184,ROUND(C184*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C184),\"\",VLOOKUP(D184,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C184),\"\",VLOOKUP(E184,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C185),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C185,ROUND(C185*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C185),\"\",VLOOKUP(D185,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C185),\"\",VLOOKUP(E185,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C186),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C186,ROUND(C186*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C186),\"\",VLOOKUP(D186,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C186),\"\",VLOOKUP(E186,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C187),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C187,ROUND(C187*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C187),\"\",VLOOKUP(D187,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C187),\"\",VLOOKUP(E187,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C188),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C188,ROUND(C188*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C188),\"\",VLOOKUP(D188,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C188),\"\",VLOOKUP(E188,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C189),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C189,ROUND(C189*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C189),\"\",VLOOKUP(D189,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C189),\"\",VLOOKUP(E189,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C190),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C190,ROUND(C190*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C190),\"\",VLOOKUP(D190,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C190),\"\",VLOOKUP(E190,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C191),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C191,ROUND(C191*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C191),\"\",VLOOKUP(D191,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C191),\"\",VLOOKUP(E191,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C192),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C192,ROUND(C192*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C192),\"\",VLOOKUP(D192,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C192),\"\",VLOOKUP(E192,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C193),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C193,ROUND(C193*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C193),\"\",VLOOKUP(D193,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C193),\"\",VLOOKUP(E193,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C194),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C194,ROUND(C194*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C194),\"\",VLOOKUP(D194,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C194),\"\",VLOOKUP(E194,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C195),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C195,ROUND(C195*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C195),\"\",VLOOKUP(D195,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C195),\"\",VLOOKUP(E195,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C196),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C196,ROUND(C196*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C196),\"\",VLOOKUP(D196,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C196),\"\",VLOOKUP(E196,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C197),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C197,ROUND(C197*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C197),\"\",VLOOKUP(D197,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C197),\"\",VLOOKUP(E197,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C198),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C198,ROUND(C198*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C198),\"\",VLOOKUP(D198,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C198),\"\",VLOOKUP(E198,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C199),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C199,ROUND(C199*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C199),\"\",VLOOKUP(D199,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C199),\"\",VLOOKUP(E199,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C200),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C200,ROUND(C200*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C200),\"\",VLOOKUP(D200,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C200),\"\",VLOOKUP(E200,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C201),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C201,ROUND(C201*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C201),\"\",VLOOKUP(D201,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C201),\"\",VLOOKUP(E201,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C202),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C202,ROUND(C202*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C202),\"\",VLOOKUP(D202,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C202),\"\",VLOOKUP(E202,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C203),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C203,ROUND(C203*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C203),\"\",VLOOKUP(D203,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C203),\"\",VLOOKUP(E203,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C204),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C204,ROUND(C204*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C204),\"\",VLOOKUP(D204,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C204),\"\",VLOOKUP(E204,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C205),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C205,ROUND(C205*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C205),\"\",VLOOKUP(D205,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C205),\"\",VLOOKUP(E205,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C206),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C206,ROUND(C206*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C206),\"\",VLOOKUP(D206,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C206),\"\",VLOOKUP(E206,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C207),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C207,ROUND(C207*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C207),\"\",VLOOKUP(D207,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C207),\"\",VLOOKUP(E207,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C208),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C208,ROUND(C208*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C208),\"\",VLOOKUP(D208,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C208),\"\",VLOOKUP(E208,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C209),\"\",IF('Project Assumptions'!$L$3=\"No\",'Employee Rates'!C209,ROUND(C209*'Data Tables'!$P$17,2)))","v":""},{"$f":"IF(ISBLANK(C209),\"\",VLOOKUP(D209,'Data Tables'!$C$8:$G$31,5))","v":""},{"$f":"IF(ISBLANK(C209),\"\",VLOOKUP(E209,'Project Assumptions'!$C$13:$D$36,2,FALSE))","v":""},"Back to Top"]

{"sheet":"Copy To Sharepoint","index":3,"n_rows":213,"n_cols":5,"rows_kept":213,"cut":false,"hidden":false,"merged":[[1,2,1,7],[5,3,5,7],[3,3,3,7],[4,3,4,7]]}
[]
[null,null,"Fixed Fee per Hour by Employee"]
[]
[null,null,"ODOT Agreement Number:",{"$f":"IF(ISBLANK('Project Assumptions'!D4),\"\",'Project Assumptions'!D4)","v":""}]
[null,null,"C-R-S:",{"$f":"IF(ISBLANK('Project Assumptions'!D5),\"\",'Project Assumptions'!D5)","v":""}]
[null,null,"Firm Name:",{"$f":"IF(ISBLANK('Project Assumptions'!D6),\"\",'Project Assumptions'!D6)","v":""}]
[]
[null,null,"Employee Name","Hourly Fixed Fee","Group"]
[null,{"$f":"IF(C9=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(ISBLANK('Employee Rates'!B10),\"\",'Employee Rates'!B10)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B10),\"\",'Employee Rates'!F10)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B10),\"\",'Employee Rates'!E10)","v":""}]
[null,{"$f":"IF(C10=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(ISBLANK('Employee Rates'!B11),\"\",'Employee Rates'!B11)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B11),\"\",'Employee Rates'!F11)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B11),\"\",'Employee Rates'!E11)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B12),\"\",'Employee Rates'!B12)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B12),\"\",'Employee Rates'!F12)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B12),\"\",'Employee Rates'!E12)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B13),\"\",'Employee Rates'!B13)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B13),\"\",'Employee Rates'!F13)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B13),\"\",'Employee Rates'!E13)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B14),\"\",'Employee Rates'!B14)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B14),\"\",'Employee Rates'!F14)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B14),\"\",'Employee Rates'!E14)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B15),\"\",'Employee Rates'!B15)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B15),\"\",'Employee Rates'!F15)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B15),\"\",'Employee Rates'!E15)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B16),\"\",'Employee Rates'!B16)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B16),\"\",'Employee Rates'!F16)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B16),\"\",'Employee Rates'!E16)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B17),\"\",'Employee Rates'!B17)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B17),\"\",'Employee Rates'!F17)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B17),\"\",'Employee Rates'!E17)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B18),\"\",'Employee Rates'!B18)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B18),\"\",'Employee Rates'!F18)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B18),\"\",'Employee Rates'!E18)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B19),\"\",'Employee Rates'!B19)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B19),\"\",'Employee Rates'!F19)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B19),\"\",'Employee Rates'!E19)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B20),\"\",'Employee Rates'!B20)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B20),\"\",'Employee Rates'!F20)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B20),\"\",'Employee Rates'!E20)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B21),\"\",'Employee Rates'!B21)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B21),\"\",'Employee Rates'!F21)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B21),\"\",'Employee Rates'!E21)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B22),\"\",'Employee Rates'!B22)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B22),\"\",'Employee Rates'!F22)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B22),\"\",'Employee Rates'!E22)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B23),\"\",'Employee Rates'!B23)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B23),\"\",'Employee Rates'!F23)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B23),\"\",'Employee Rates'!E23)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B24),\"\",'Employee Rates'!B24)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B24),\"\",'Employee Rates'!F24)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B24),\"\",'Employee Rates'!E24)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B25),\"\",'Employee Rates'!B25)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B25),\"\",'Employee Rates'!F25)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B25),\"\",'Employee Rates'!E25)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B26),\"\",'Employee Rates'!B26)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B26),\"\",'Employee Rates'!F26)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B26),\"\",'Employee Rates'!E26)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B27),\"\",'Employee Rates'!B27)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B27),\"\",'Employee Rates'!F27)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B27),\"\",'Employee Rates'!E27)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B28),\"\",'Employee Rates'!B28)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B28),\"\",'Employee Rates'!F28)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B28),\"\",'Employee Rates'!E28)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B29),\"\",'Employee Rates'!B29)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B29),\"\",'Employee Rates'!F29)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B29),\"\",'Employee Rates'!E29)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B30),\"\",'Employee Rates'!B30)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B30),\"\",'Employee Rates'!F30)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B30),\"\",'Employee Rates'!E30)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B31),\"\",'Employee Rates'!B31)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B31),\"\",'Employee Rates'!F31)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B31),\"\",'Employee Rates'!E31)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B32),\"\",'Employee Rates'!B32)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B32),\"\",'Employee Rates'!F32)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B32),\"\",'Employee Rates'!E32)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B33),\"\",'Employee Rates'!B33)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B33),\"\",'Employee Rates'!F33)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B33),\"\",'Employee Rates'!E33)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B34),\"\",'Employee Rates'!B34)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B34),\"\",'Employee Rates'!F34)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B34),\"\",'Employee Rates'!E34)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B35),\"\",'Employee Rates'!B35)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B35),\"\",'Employee Rates'!F35)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B35),\"\",'Employee Rates'!E35)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B36),\"\",'Employee Rates'!B36)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B36),\"\",'Employee Rates'!F36)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B36),\"\",'Employee Rates'!E36)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B37),\"\",'Employee Rates'!B37)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B37),\"\",'Employee Rates'!F37)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B37),\"\",'Employee Rates'!E37)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B38),\"\",'Employee Rates'!B38)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B38),\"\",'Employee Rates'!F38)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B38),\"\",'Employee Rates'!E38)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B39),\"\",'Employee Rates'!B39)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B39),\"\",'Employee Rates'!F39)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B39),\"\",'Employee Rates'!E39)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B40),\"\",'Employee Rates'!B40)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B40),\"\",'Employee Rates'!F40)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B40),\"\",'Employee Rates'!E40)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B41),\"\",'Employee Rates'!B41)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B41),\"\",'Employee Rates'!F41)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B41),\"\",'Employee Rates'!E41)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B42),\"\",'Employee Rates'!B42)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B42),\"\",'Employee Rates'!F42)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B42),\"\",'Employee Rates'!E42)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B43),\"\",'Employee Rates'!B43)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B43),\"\",'Employee Rates'!F43)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B43),\"\",'Employee Rates'!E43)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B44),\"\",'Employee Rates'!B44)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B44),\"\",'Employee Rates'!F44)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B44),\"\",'Employee Rates'!E44)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B45),\"\",'Employee Rates'!B45)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B45),\"\",'Employee Rates'!F45)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B45),\"\",'Employee Rates'!E45)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B46),\"\",'Employee Rates'!B46)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B46),\"\",'Employee Rates'!F46)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B46),\"\",'Employee Rates'!E46)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B47),\"\",'Employee Rates'!B47)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B47),\"\",'Employee Rates'!F47)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B47),\"\",'Employee Rates'!E47)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B48),\"\",'Employee Rates'!B48)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B48),\"\",'Employee Rates'!F48)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B48),\"\",'Employee Rates'!E48)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B49),\"\",'Employee Rates'!B49)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B49),\"\",'Employee Rates'!F49)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B49),\"\",'Employee Rates'!E49)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B50),\"\",'Employee Rates'!B50)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B50),\"\",'Employee Rates'!F50)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B50),\"\",'Employee Rates'!E50)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B51),\"\",'Employee Rates'!B51)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B51),\"\",'Employee Rates'!F51)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B51),\"\",'Employee Rates'!E51)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B52),\"\",'Employee Rates'!B52)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B52),\"\",'Employee Rates'!F52)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B52),\"\",'Employee Rates'!E52)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B53),\"\",'Employee Rates'!B53)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B53),\"\",'Employee Rates'!F53)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B53),\"\",'Employee Rates'!E53)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B54),\"\",'Employee Rates'!B54)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B54),\"\",'Employee Rates'!F54)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B54),\"\",'Employee Rates'!E54)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B55),\"\",'Employee Rates'!B55)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B55),\"\",'Employee Rates'!F55)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B55),\"\",'Employee Rates'!E55)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B56),\"\",'Employee Rates'!B56)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B56),\"\",'Employee Rates'!F56)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B56),\"\",'Employee Rates'!E56)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B57),\"\",'Employee Rates'!B57)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B57),\"\",'Employee Rates'!F57)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B57),\"\",'Employee Rates'!E57)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B58),\"\",'Employee Rates'!B58)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B58),\"\",'Employee Rates'!F58)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B58),\"\",'Employee Rates'!E58)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B59),\"\",'Employee Rates'!B59)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B59),\"\",'Employee Rates'!F59)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B59),\"\",'Employee Rates'!E59)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B60),\"\",'Employee Rates'!B60)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B60),\"\",'Employee Rates'!F60)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B60),\"\",'Employee Rates'!E60)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B61),\"\",'Employee Rates'!B61)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B61),\"\",'Employee Rates'!F61)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B61),\"\",'Employee Rates'!E61)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B62),\"\",'Employee Rates'!B62)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B62),\"\",'Employee Rates'!F62)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B62),\"\",'Employee Rates'!E62)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B63),\"\",'Employee Rates'!B63)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B63),\"\",'Employee Rates'!F63)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B63),\"\",'Employee Rates'!E63)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B64),\"\",'Employee Rates'!B64)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B64),\"\",'Employee Rates'!F64)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B64),\"\",'Employee Rates'!E64)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B65),\"\",'Employee Rates'!B65)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B65),\"\",'Employee Rates'!F65)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B65),\"\",'Employee Rates'!E65)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B66),\"\",'Employee Rates'!B66)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B66),\"\",'Employee Rates'!F66)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B66),\"\",'Employee Rates'!E66)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B67),\"\",'Employee Rates'!B67)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B67),\"\",'Employee Rates'!F67)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B67),\"\",'Employee Rates'!E67)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B68),\"\",'Employee Rates'!B68)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B68),\"\",'Employee Rates'!F68)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B68),\"\",'Employee Rates'!E68)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B69),\"\",'Employee Rates'!B69)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B69),\"\",'Employee Rates'!F69)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B69),\"\",'Employee Rates'!E69)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B70),\"\",'Employee Rates'!B70)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B70),\"\",'Employee Rates'!F70)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B70),\"\",'Employee Rates'!E70)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B71),\"\",'Employee Rates'!B71)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B71),\"\",'Employee Rates'!F71)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B71),\"\",'Employee Rates'!E71)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B72),\"\",'Employee Rates'!B72)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B72),\"\",'Employee Rates'!F72)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B72),\"\",'Employee Rates'!E72)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B73),\"\",'Employee Rates'!B73)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B73),\"\",'Employee Rates'!F73)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B73),\"\",'Employee Rates'!E73)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B74),\"\",'Employee Rates'!B74)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B74),\"\",'Employee Rates'!F74)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B74),\"\",'Employee Rates'!E74)","v":""}]
[null,{"$f":"IF(C74=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(ISBLANK('Employee Rates'!B75),\"\",'Employee Rates'!B75)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B75),\"\",'Employee Rates'!F75)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B75),\"\",'Employee Rates'!E75)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B76),\"\",'Employee Rates'!B76)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B76),\"\",'Employee Rates'!F76)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B76),\"\",'Employee Rates'!E76)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B77),\"\",'Employee Rates'!B77)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B77),\"\",'Employee Rates'!F77)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B77),\"\",'Employee Rates'!E77)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B78),\"\",'Employee Rates'!B78)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B78),\"\",'Employee Rates'!F78)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B78),\"\",'Employee Rates'!E78)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B79),\"\",'Employee Rates'!B79)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B79),\"\",'Employee Rates'!F79)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B79),\"\",'Employee Rates'!E79)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B80),\"\",'Employee Rates'!B80)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B80),\"\",'Employee Rates'!F80)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B80),\"\",'Employee Rates'!E80)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B81),\"\",'Employee Rates'!B81)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B81),\"\",'Employee Rates'!F81)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B81),\"\",'Employee Rates'!E81)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B82),\"\",'Employee Rates'!B82)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B82),\"\",'Employee Rates'!F82)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B82),\"\",'Employee Rates'!E82)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B83),\"\",'Employee Rates'!B83)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B83),\"\",'Employee Rates'!F83)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B83),\"\",'Employee Rates'!E83)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B84),\"\",'Employee Rates'!B84)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B84),\"\",'Employee Rates'!F84)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B84),\"\",'Employee Rates'!E84)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B85),\"\",'Employee Rates'!B85)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B85),\"\",'Employee Rates'!F85)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B85),\"\",'Employee Rates'!E85)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B86),\"\",'Employee Rates'!B86)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B86),\"\",'Employee Rates'!F86)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B86),\"\",'Employee Rates'!E86)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B87),\"\",'Employee Rates'!B87)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B87),\"\",'Employee Rates'!F87)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B87),\"\",'Employee Rates'!E87)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B88),\"\",'Employee Rates'!B88)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B88),\"\",'Employee Rates'!F88)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B88),\"\",'Employee Rates'!E88)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B89),\"\",'Employee Rates'!B89)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B89),\"\",'Employee Rates'!F89)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B89),\"\",'Employee Rates'!E89)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B90),\"\",'Employee Rates'!B90)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B90),\"\",'Employee Rates'!F90)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B90),\"\",'Employee Rates'!E90)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B91),\"\",'Employee Rates'!B91)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B91),\"\",'Employee Rates'!F91)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B91),\"\",'Employee Rates'!E91)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B92),\"\",'Employee Rates'!B92)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B92),\"\",'Employee Rates'!F92)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B92),\"\",'Employee Rates'!E92)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B93),\"\",'Employee Rates'!B93)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B93),\"\",'Employee Rates'!F93)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B93),\"\",'Employee Rates'!E93)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B94),\"\",'Employee Rates'!B94)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B94),\"\",'Employee Rates'!F94)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B94),\"\",'Employee Rates'!E94)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B95),\"\",'Employee Rates'!B95)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B95),\"\",'Employee Rates'!F95)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B95),\"\",'Employee Rates'!E95)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B96),\"\",'Employee Rates'!B96)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B96),\"\",'Employee Rates'!F96)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B96),\"\",'Employee Rates'!E96)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B97),\"\",'Employee Rates'!B97)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B97),\"\",'Employee Rates'!F97)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B97),\"\",'Employee Rates'!E97)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B98),\"\",'Employee Rates'!B98)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B98),\"\",'Employee Rates'!F98)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B98),\"\",'Employee Rates'!E98)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B99),\"\",'Employee Rates'!B99)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B99),\"\",'Employee Rates'!F99)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B99),\"\",'Employee Rates'!E99)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B100),\"\",'Employee Rates'!B100)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B100),\"\",'Employee Rates'!F100)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B100),\"\",'Employee Rates'!E100)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B101),\"\",'Employee Rates'!B101)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B101),\"\",'Employee Rates'!F101)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B101),\"\",'Employee Rates'!E101)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B102),\"\",'Employee Rates'!B102)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B102),\"\",'Employee Rates'!F102)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B102),\"\",'Employee Rates'!E102)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B103),\"\",'Employee Rates'!B103)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B103),\"\",'Employee Rates'!F103)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B103),\"\",'Employee Rates'!E103)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B104),\"\",'Employee Rates'!B104)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B104),\"\",'Employee Rates'!F104)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B104),\"\",'Employee Rates'!E104)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B105),\"\",'Employee Rates'!B105)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B105),\"\",'Employee Rates'!F105)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B105),\"\",'Employee Rates'!E105)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B106),\"\",'Employee Rates'!B106)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B106),\"\",'Employee Rates'!F106)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B106),\"\",'Employee Rates'!E106)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B107),\"\",'Employee Rates'!B107)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B107),\"\",'Employee Rates'!F107)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B107),\"\",'Employee Rates'!E107)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B108),\"\",'Employee Rates'!B108)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B108),\"\",'Employee Rates'!F108)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B108),\"\",'Employee Rates'!E108)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B109),\"\",'Employee Rates'!B109)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B109),\"\",'Employee Rates'!F109)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B109),\"\",'Employee Rates'!E109)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B110),\"\",'Employee Rates'!B110)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B110),\"\",'Employee Rates'!F110)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B110),\"\",'Employee Rates'!E110)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B111),\"\",'Employee Rates'!B111)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B111),\"\",'Employee Rates'!F111)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B111),\"\",'Employee Rates'!E111)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B112),\"\",'Employee Rates'!B112)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B112),\"\",'Employee Rates'!F112)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B112),\"\",'Employee Rates'!E112)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B113),\"\",'Employee Rates'!B113)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B113),\"\",'Employee Rates'!F113)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B113),\"\",'Employee Rates'!E113)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B114),\"\",'Employee Rates'!B114)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B114),\"\",'Employee Rates'!F114)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B114),\"\",'Employee Rates'!E114)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B115),\"\",'Employee Rates'!B115)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B115),\"\",'Employee Rates'!F115)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B115),\"\",'Employee Rates'!E115)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B116),\"\",'Employee Rates'!B116)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B116),\"\",'Employee Rates'!F116)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B116),\"\",'Employee Rates'!E116)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B117),\"\",'Employee Rates'!B117)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B117),\"\",'Employee Rates'!F117)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B117),\"\",'Employee Rates'!E117)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B118),\"\",'Employee Rates'!B118)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B118),\"\",'Employee Rates'!F118)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B118),\"\",'Employee Rates'!E118)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B119),\"\",'Employee Rates'!B119)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B119),\"\",'Employee Rates'!F119)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B119),\"\",'Employee Rates'!E119)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B120),\"\",'Employee Rates'!B120)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B120),\"\",'Employee Rates'!F120)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B120),\"\",'Employee Rates'!E120)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B121),\"\",'Employee Rates'!B121)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B121),\"\",'Employee Rates'!F121)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B121),\"\",'Employee Rates'!E121)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B122),\"\",'Employee Rates'!B122)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B122),\"\",'Employee Rates'!F122)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B122),\"\",'Employee Rates'!E122)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B123),\"\",'Employee Rates'!B123)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B123),\"\",'Employee Rates'!F123)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B123),\"\",'Employee Rates'!E123)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B124),\"\",'Employee Rates'!B124)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B124),\"\",'Employee Rates'!F124)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B124),\"\",'Employee Rates'!E124)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B125),\"\",'Employee Rates'!B125)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B125),\"\",'Employee Rates'!F125)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B125),\"\",'Employee Rates'!E125)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B126),\"\",'Employee Rates'!B126)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B126),\"\",'Employee Rates'!F126)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B126),\"\",'Employee Rates'!E126)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B127),\"\",'Employee Rates'!B127)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B127),\"\",'Employee Rates'!F127)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B127),\"\",'Employee Rates'!E127)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B128),\"\",'Employee Rates'!B128)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B128),\"\",'Employee Rates'!F128)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B128),\"\",'Employee Rates'!E128)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B129),\"\",'Employee Rates'!B129)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B129),\"\",'Employee Rates'!F129)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B129),\"\",'Employee Rates'!E129)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B130),\"\",'Employee Rates'!B130)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B130),\"\",'Employee Rates'!F130)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B130),\"\",'Employee Rates'!E130)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B131),\"\",'Employee Rates'!B131)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B131),\"\",'Employee Rates'!F131)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B131),\"\",'Employee Rates'!E131)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B132),\"\",'Employee Rates'!B132)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B132),\"\",'Employee Rates'!F132)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B132),\"\",'Employee Rates'!E132)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B133),\"\",'Employee Rates'!B133)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B133),\"\",'Employee Rates'!F133)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B133),\"\",'Employee Rates'!E133)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B134),\"\",'Employee Rates'!B134)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B134),\"\",'Employee Rates'!F134)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B134),\"\",'Employee Rates'!E134)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B135),\"\",'Employee Rates'!B135)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B135),\"\",'Employee Rates'!F135)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B135),\"\",'Employee Rates'!E135)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B136),\"\",'Employee Rates'!B136)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B136),\"\",'Employee Rates'!F136)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B136),\"\",'Employee Rates'!E136)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B137),\"\",'Employee Rates'!B137)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B137),\"\",'Employee Rates'!F137)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B137),\"\",'Employee Rates'!E137)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B138),\"\",'Employee Rates'!B138)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B138),\"\",'Employee Rates'!F138)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B138),\"\",'Employee Rates'!E138)","v":""}]
[null,{"$f":"IF(C138=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(ISBLANK('Employee Rates'!B139),\"\",'Employee Rates'!B139)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B139),\"\",'Employee Rates'!F139)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B139),\"\",'Employee Rates'!E139)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B140),\"\",'Employee Rates'!B140)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B140),\"\",'Employee Rates'!F140)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B140),\"\",'Employee Rates'!E140)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B141),\"\",'Employee Rates'!B141)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B141),\"\",'Employee Rates'!F141)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B141),\"\",'Employee Rates'!E141)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B142),\"\",'Employee Rates'!B142)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B142),\"\",'Employee Rates'!F142)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B142),\"\",'Employee Rates'!E142)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B143),\"\",'Employee Rates'!B143)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B143),\"\",'Employee Rates'!F143)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B143),\"\",'Employee Rates'!E143)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B144),\"\",'Employee Rates'!B144)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B144),\"\",'Employee Rates'!F144)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B144),\"\",'Employee Rates'!E144)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B145),\"\",'Employee Rates'!B145)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B145),\"\",'Employee Rates'!F145)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B145),\"\",'Employee Rates'!E145)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B146),\"\",'Employee Rates'!B146)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B146),\"\",'Employee Rates'!F146)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B146),\"\",'Employee Rates'!E146)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B147),\"\",'Employee Rates'!B147)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B147),\"\",'Employee Rates'!F147)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B147),\"\",'Employee Rates'!E147)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B148),\"\",'Employee Rates'!B148)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B148),\"\",'Employee Rates'!F148)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B148),\"\",'Employee Rates'!E148)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B149),\"\",'Employee Rates'!B149)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B149),\"\",'Employee Rates'!F149)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B149),\"\",'Employee Rates'!E149)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B150),\"\",'Employee Rates'!B150)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B150),\"\",'Employee Rates'!F150)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B150),\"\",'Employee Rates'!E150)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B151),\"\",'Employee Rates'!B151)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B151),\"\",'Employee Rates'!F151)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B151),\"\",'Employee Rates'!E151)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B152),\"\",'Employee Rates'!B152)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B152),\"\",'Employee Rates'!F152)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B152),\"\",'Employee Rates'!E152)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B153),\"\",'Employee Rates'!B153)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B153),\"\",'Employee Rates'!F153)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B153),\"\",'Employee Rates'!E153)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B154),\"\",'Employee Rates'!B154)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B154),\"\",'Employee Rates'!F154)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B154),\"\",'Employee Rates'!E154)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B155),\"\",'Employee Rates'!B155)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B155),\"\",'Employee Rates'!F155)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B155),\"\",'Employee Rates'!E155)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B156),\"\",'Employee Rates'!B156)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B156),\"\",'Employee Rates'!F156)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B156),\"\",'Employee Rates'!E156)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B157),\"\",'Employee Rates'!B157)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B157),\"\",'Employee Rates'!F157)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B157),\"\",'Employee Rates'!E157)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B158),\"\",'Employee Rates'!B158)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B158),\"\",'Employee Rates'!F158)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B158),\"\",'Employee Rates'!E158)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B159),\"\",'Employee Rates'!B159)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B159),\"\",'Employee Rates'!F159)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B159),\"\",'Employee Rates'!E159)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B160),\"\",'Employee Rates'!B160)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B160),\"\",'Employee Rates'!F160)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B160),\"\",'Employee Rates'!E160)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B161),\"\",'Employee Rates'!B161)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B161),\"\",'Employee Rates'!F161)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B161),\"\",'Employee Rates'!E161)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B162),\"\",'Employee Rates'!B162)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B162),\"\",'Employee Rates'!F162)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B162),\"\",'Employee Rates'!E162)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B163),\"\",'Employee Rates'!B163)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B163),\"\",'Employee Rates'!F163)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B163),\"\",'Employee Rates'!E163)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B164),\"\",'Employee Rates'!B164)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B164),\"\",'Employee Rates'!F164)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B164),\"\",'Employee Rates'!E164)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B165),\"\",'Employee Rates'!B165)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B165),\"\",'Employee Rates'!F165)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B165),\"\",'Employee Rates'!E165)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B166),\"\",'Employee Rates'!B166)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B166),\"\",'Employee Rates'!F166)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B166),\"\",'Employee Rates'!E166)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B167),\"\",'Employee Rates'!B167)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B167),\"\",'Employee Rates'!F167)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B167),\"\",'Employee Rates'!E167)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B168),\"\",'Employee Rates'!B168)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B168),\"\",'Employee Rates'!F168)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B168),\"\",'Employee Rates'!E168)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B169),\"\",'Employee Rates'!B169)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B169),\"\",'Employee Rates'!F169)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B169),\"\",'Employee Rates'!E169)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B170),\"\",'Employee Rates'!B170)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B170),\"\",'Employee Rates'!F170)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B170),\"\",'Employee Rates'!E170)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B171),\"\",'Employee Rates'!B171)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B171),\"\",'Employee Rates'!F171)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B171),\"\",'Employee Rates'!E171)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B172),\"\",'Employee Rates'!B172)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B172),\"\",'Employee Rates'!F172)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B172),\"\",'Employee Rates'!E172)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B173),\"\",'Employee Rates'!B173)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B173),\"\",'Employee Rates'!F173)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B173),\"\",'Employee Rates'!E173)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B174),\"\",'Employee Rates'!B174)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B174),\"\",'Employee Rates'!F174)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B174),\"\",'Employee Rates'!E174)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B175),\"\",'Employee Rates'!B175)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B175),\"\",'Employee Rates'!F175)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B175),\"\",'Employee Rates'!E175)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B176),\"\",'Employee Rates'!B176)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B176),\"\",'Employee Rates'!F176)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B176),\"\",'Employee Rates'!E176)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B177),\"\",'Employee Rates'!B177)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B177),\"\",'Employee Rates'!F177)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B177),\"\",'Employee Rates'!E177)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B178),\"\",'Employee Rates'!B178)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B178),\"\",'Employee Rates'!F178)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B178),\"\",'Employee Rates'!E178)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B179),\"\",'Employee Rates'!B179)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B179),\"\",'Employee Rates'!F179)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B179),\"\",'Employee Rates'!E179)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B180),\"\",'Employee Rates'!B180)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B180),\"\",'Employee Rates'!F180)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B180),\"\",'Employee Rates'!E180)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B181),\"\",'Employee Rates'!B181)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B181),\"\",'Employee Rates'!F181)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B181),\"\",'Employee Rates'!E181)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B182),\"\",'Employee Rates'!B182)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B182),\"\",'Employee Rates'!F182)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B182),\"\",'Employee Rates'!E182)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B183),\"\",'Employee Rates'!B183)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B183),\"\",'Employee Rates'!F183)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B183),\"\",'Employee Rates'!E183)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B184),\"\",'Employee Rates'!B184)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B184),\"\",'Employee Rates'!F184)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B184),\"\",'Employee Rates'!E184)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B185),\"\",'Employee Rates'!B185)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B185),\"\",'Employee Rates'!F185)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B185),\"\",'Employee Rates'!E185)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B186),\"\",'Employee Rates'!B186)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B186),\"\",'Employee Rates'!F186)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B186),\"\",'Employee Rates'!E186)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B187),\"\",'Employee Rates'!B187)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B187),\"\",'Employee Rates'!F187)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B187),\"\",'Employee Rates'!E187)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B188),\"\",'Employee Rates'!B188)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B188),\"\",'Employee Rates'!F188)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B188),\"\",'Employee Rates'!E188)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B189),\"\",'Employee Rates'!B189)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B189),\"\",'Employee Rates'!F189)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B189),\"\",'Employee Rates'!E189)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B190),\"\",'Employee Rates'!B190)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B190),\"\",'Employee Rates'!F190)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B190),\"\",'Employee Rates'!E190)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B191),\"\",'Employee Rates'!B191)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B191),\"\",'Employee Rates'!F191)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B191),\"\",'Employee Rates'!E191)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B192),\"\",'Employee Rates'!B192)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B192),\"\",'Employee Rates'!F192)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B192),\"\",'Employee Rates'!E192)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B193),\"\",'Employee Rates'!B193)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B193),\"\",'Employee Rates'!F193)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B193),\"\",'Employee Rates'!E193)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B194),\"\",'Employee Rates'!B194)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B194),\"\",'Employee Rates'!F194)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B194),\"\",'Employee Rates'!E194)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B195),\"\",'Employee Rates'!B195)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B195),\"\",'Employee Rates'!F195)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B195),\"\",'Employee Rates'!E195)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B196),\"\",'Employee Rates'!B196)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B196),\"\",'Employee Rates'!F196)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B196),\"\",'Employee Rates'!E196)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B197),\"\",'Employee Rates'!B197)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B197),\"\",'Employee Rates'!F197)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B197),\"\",'Employee Rates'!E197)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B198),\"\",'Employee Rates'!B198)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B198),\"\",'Employee Rates'!F198)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B198),\"\",'Employee Rates'!E198)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B199),\"\",'Employee Rates'!B199)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B199),\"\",'Employee Rates'!F199)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B199),\"\",'Employee Rates'!E199)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B200),\"\",'Employee Rates'!B200)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B200),\"\",'Employee Rates'!F200)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B200),\"\",'Employee Rates'!E200)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B201),\"\",'Employee Rates'!B201)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B201),\"\",'Employee Rates'!F201)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B201),\"\",'Employee Rates'!E201)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B202),\"\",'Employee Rates'!B202)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B202),\"\",'Employee Rates'!F202)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B202),\"\",'Employee Rates'!E202)","v":""}]
[null,{"$f":"IF(C202=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(ISBLANK('Employee Rates'!B203),\"\",'Employee Rates'!B203)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B203),\"\",'Employee Rates'!F203)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B203),\"\",'Employee Rates'!E203)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B204),\"\",'Employee Rates'!B204)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B204),\"\",'Employee Rates'!F204)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B204),\"\",'Employee Rates'!E204)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B205),\"\",'Employee Rates'!B205)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B205),\"\",'Employee Rates'!F205)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B205),\"\",'Employee Rates'!E205)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B206),\"\",'Employee Rates'!B206)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B206),\"\",'Employee Rates'!F206)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B206),\"\",'Employee Rates'!E206)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B207),\"\",'Employee Rates'!B207)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B207),\"\",'Employee Rates'!F207)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B207),\"\",'Employee Rates'!E207)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B208),\"\",'Employee Rates'!B208)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B208),\"\",'Employee Rates'!F208)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B208),\"\",'Employee Rates'!E208)","v":""}]
[null,"N",{"$f":"IF(ISBLANK('Employee Rates'!B209),\"\",'Employee Rates'!B209)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B209),\"\",'Employee Rates'!F209)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B209),\"\",'Employee Rates'!E209)","v":""}]
[null,null,{"$f":"IF(ISBLANK('Employee Rates'!B210),\"\",'Employee Rates'!B210)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B210),\"\",'Employee Rates'!F210)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B210),\"\",'Employee Rates'!E210)","v":""}]
[null,null,{"$f":"IF(ISBLANK('Employee Rates'!B211),\"\",'Employee Rates'!B211)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B211),\"\",'Employee Rates'!F211)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B211),\"\",'Employee Rates'!E211)","v":""}]
[null,null,{"$f":"IF(ISBLANK('Employee Rates'!B212),\"\",'Employee Rates'!B212)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B212),\"\",'Employee Rates'!F212)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B212),\"\",'Employee Rates'!E212)","v":""}]
[null,null,{"$f":"IF(ISBLANK('Employee Rates'!B213),\"\",'Employee Rates'!B213)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B213),\"\",'Employee Rates'!F213)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B213),\"\",'Employee Rates'!E213)","v":""}]
[null,null,{"$f":"IF(ISBLANK('Employee Rates'!B214),\"\",'Employee Rates'!B214)","v":""},{"$f":"IF(ISBLANK('Employee Rates'!B214),\"\",'Employee Rates'!F214)","v":""}]

{"sheet":"Instructions","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Instructions"]
[]
[null,"The purpose of this spreadsheet is to categorize individual employees into pay groups to establish hourly fixed fees on consulting contracts using this pay type."]
[]
[null,"The consultant is to enter data into the yellow cells on the yellow tabs."]
[]
[null,"Step 1:"]
[null,"Complete the yellow cells in the Project Assumptions tab."]
[null,null,"The weighted average overhead rate is a number calculated annually by ODOT. Contact Consultant Services if you do not have this number."]
[null,null,"The project start and ends dates are estimates of the dates the consultant will be beginning and ending work on the project."]
[null,null,"The Annual Wage Escalation Percentage is the consultant's estimated average annual increase in employee wages."]
[]
[null,"Step 2:"]
[null,"Complete the yellow cells in the Employee Rates tab."]
[null,null,"Include all employees that may be working on the project."]
[null,null,null,"The sheet holds 200 employees. If more than 200 names are required, use a second template for the overflow."]
[null,null,"Identify the actual pay rates of employees, using rates as of the day the template is being completed."]
[null,null,null,"Do not factor in any anticipated raises, as they are already calculated in the template."]
[null,null,null,"For salaried employees, use the method employed by the company (i.e., standard or effective hourly rate) when allocating costs to direct and indirect labor."]
[]
[null,"Step 3:"]
[null,"Click the Sort Pay Rates macro button on the Copy to Sharepoint tab."]
[null,null,"The fixed fees will be shown on this tab."]
[]
[null,"Step 4:"]
[null,"Submit to ODOT."]
[]
[null,"Upon execution, ODOT will post to Sharepoint."]

{"sheet":"Data Tables","index":5,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"K4-K3+1","v":1}]
[null,null,null,null,null,null,null,null,null,"Today Year",{"$f":"ROUND(TEXT('Project Assumptions'!I3,\"yyyy\"),0)","v":1900},{"$f":"'Project Assumptions'!I3","v":"00:00:00"},null,"Proj. Len.",{"$f":"L4-L3+1","v":1},"<--Days"]
[null,null,null,null,null,null,null,null,null,"Start Year",{"$f":"ROUND(TEXT('Project Assumptions'!I4,\"yyyy\"),0)","v":1900},{"$f":"'Project Assumptions'!I4","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"End Year",{"$f":"ROUND(TEXT('Project Assumptions'!I5,\"yyyy\"),0)","v":1900},{"$f":"'Project Assumptions'!I5","v":"00:00:00"}]
[]
[null,null,null,null,null,null,null,null,null,"Year","Yr. Start","Yr End","Days","% of Proj","Esc. Factor","Weighted Esc."]
[null,"Group","Min Pay","Max Pay","Median","Net Fee",{"$f":"B7","v":"Group"},null,1,{"$f":"ROUND(K3,0)","v":1900},{"$f":"L3","v":"00:00:00"},{"$f":"IF(K7=\"\",\"\",IF(YEAR($L$3)=YEAR($L$4),$L$4,IF($K$4=J7,$L$4,EOMONTH(K7,12-TEXT(K7,\"mm\")))))","v":"00:00:00"},{"$f":"IF(J7=\"\",\"\",L7-K7+1)","v":1},{"$f":"IF(J7=\"\",\"\",M7/$O$2)","v":1},{"$f":"IF(J7=\"\",\"\",(1+'Project Assumptions'!$I$6)^(K3-K2))","v":1},{"$f":"IF(J7=\"\",\"\",N7*O7)","v":1}]
[null,1,0,15,{"$f":"D8-2.5","v":12.5},{"$f":"ROUND(E8*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E8*'Project Assumptions'!$D$9,2)","v":0},{"$f":"B8","v":1},null,2,{"$f":"IF(I8>$K$1,\"\",ROUND(J7+1,0))","v":""},{"$f":"IF(J8=\"\",\"\",L7+1)","v":""},{"$f":"IF(K8=\"\",\"\",IF(YEAR($L$3)=YEAR($L$4),$L$4,IF($K$4=J8,$L$4,EOMONTH(K8,12-TEXT(K8,\"mm\")))))","v":""},{"$f":"IF(J8=\"\",\"\",L8-K8+1)","v":""},"",{"$f":"IF(J8=\"\",\"\",O7*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,2,{"$f":"D8+0.01","v":15.01},{"$f":"D8+5","v":20},{"$f":"MEDIAN(D8:D9)","v":17.5},{"$f":"ROUND(E9*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E9*'Project Assumptions'!$D$9,2)","v":0},2,null,3,{"$f":"IF(I9>$K$1,\"\",ROUND(J8+1,0))","v":""},{"$f":"IF(J9=\"\",\"\",L8+1)","v":""},"","","",{"$f":"IF(J9=\"\",\"\",O8*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,3,{"$f":"D9+0.01","v":20.010000000000002},{"$f":"D9+5","v":25},{"$f":"MEDIAN(D9:D10)","v":22.5},{"$f":"ROUND(E10*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E10*'Project Assumptions'!$D$9,2)","v":0},3,null,4,"","","","","",{"$f":"IF(J10=\"\",\"\",O9*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,4,25.01,30,27.5,{"$f":"ROUND(E11*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E11*'Project Assumptions'!$D$9,2)","v":0},4,null,5,"","","","","",{"$f":"IF(J11=\"\",\"\",O10*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,5,30.01,35,32.5,{"$f":"ROUND(E12*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E12*'Project Assumptions'!$D$9,2)","v":0},5,null,6,"","","","","",{"$f":"IF(J12=\"\",\"\",O11*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,6,35.01,40,37.5,{"$f":"ROUND(E13*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E13*'Project Assumptions'!$D$9,2)","v":0},6,null,7,"","","","","",{"$f":"IF(J13=\"\",\"\",O12*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,7,40.01,45,42.5,{"$f":"ROUND(E14*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E14*'Project Assumptions'!$D$9,2)","v":0},7,null,8,"","","","","",{"$f":"IF(J14=\"\",\"\",O13*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,8,45.01,50,47.5,{"$f":"ROUND(E15*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E15*'Project Assumptions'!$D$9,2)","v":0},8,null,9,"","","","","",{"$f":"IF(J15=\"\",\"\",O14*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,9,50.01,55,52.5,{"$f":"ROUND(E16*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E16*'Project Assumptions'!$D$9,2)","v":0},9,null,10,"","","","","",{"$f":"IF(J16=\"\",\"\",O15*(1+'Project Assumptions'!$I$6))","v":""},""]
[null,10,55.01,60,57.5,{"$f":"ROUND(E17*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E17*'Project Assumptions'!$D$9,2)","v":0},10,null,null,null,null,null,null,{"$f":"SUM(N7:N16)","v":1},null,{"$f":"SUM(P7:P16)","v":1},"<---Escalation Factor"]
[null,11,60.01,65,62.5,{"$f":"ROUND(E18*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E18*'Project Assumptions'!$D$9,2)","v":0},11]
[null,12,65.010000000000005,70,67.5,{"$f":"ROUND(E19*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E19*'Project Assumptions'!$D$9,2)","v":0},12]
[null,13,70.010000000000005,75,72.5,{"$f":"ROUND(E20*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E20*'Project Assumptions'!$D$9,2)","v":0},13]
[null,14,75.010000000000005,80,77.5,{"$f":"ROUND(E21*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E21*'Project Assumptions'!$D$9,2)","v":0},14]
[null,15,80.010000000000005,85,82.5,{"$f":"ROUND(E22*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E22*'Project Assumptions'!$D$9,2)","v":0},15]
[null,16,85.01,90,87.5,{"$f":"ROUND(E23*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E23*'Project Assumptions'!$D$9,2)","v":0},16]
[null,17,90.01,95,92.5,{"$f":"ROUND(E24*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E24*'Project Assumptions'!$D$9,2)","v":0},17]
[null,18,95.01,100,97.5,{"$f":"ROUND(E25*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E25*'Project Assumptions'!$D$9,2)","v":0},18]
[null,19,100.01,105,102.5,{"$f":"ROUND(E26*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E26*'Project Assumptions'!$D$9,2)","v":0},19]
[null,20,105.01,110,107.5,{"$f":"ROUND(E27*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E27*'Project Assumptions'!$D$9,2)","v":0},20]
[null,21,110.01,115,112.5,{"$f":"ROUND(E28*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E28*'Project Assumptions'!$D$9,2)","v":0},21]
[null,22,115.01,120,117.5,{"$f":"ROUND(E29*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E29*'Project Assumptions'!$D$9,2)","v":0},22]
[null,23,120.01,125,122.5,{"$f":"ROUND(E30*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E30*'Project Assumptions'!$D$9,2)","v":0},23]
[null,24,125.01,130,127.5,{"$f":"ROUND(E31*'Project Assumptions'!$D$8*'Project Assumptions'!$D$9+E31*'Project Assumptions'!$D$9,2)","v":0},24]